﻿using System;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using DAL;
using MOD;

namespace BLL
{
    public class B_YongHu
    {
        private int iDataConn = DataBase.IN_S2;
        public DataTable SelectLogin( M_YongHu mYh,int iServerType )
        {
            DataBase dDb = new DataBase();
            StringBuilder sCmdText = new StringBuilder();
            iDataConn = iServerType;

            sCmdText.Append("Select * From YongHu ");
            sCmdText.Append("Where DengLuMing = @DengLuMing ");
            sCmdText.Append("and ");
            sCmdText.Append("MiMa = @MiMa ");

            SqlParameter[] sSp = {
                                    new SqlParameter("@DengLuMing",SqlDbType.Char,16),
                                    new SqlParameter("@MiMa",SqlDbType.Char,32)       
                                 };

            sSp[0].Value = mYh.DengLuMing;
            sSp[1].Value = mYh.MiMa;

            return dDb.GetDataTable(sCmdText.ToString(), iDataConn, sSp);
        }

    }
}
